- Software Requirement: Database backup of Oracle 12c can be run on Windows Server 2008/ 2008 R2/ 2012/ 2012 R2/ 2016.
- %edition_name% Installation: Latest version of %edition_name% must be installed on the Oracle database server.
- Oracle Database Server Add-On Module: Make sure that the Oracle Database Server add-on module is enabled for your %edition_name% user account.
- Backup Quota Requirement: Make sure that your %edition_name% user account has sufficient storage quota assigned to accommodate the storage of Oracle database backup set and retention policy.
- Continuous backup module: The Continuous backup add-on module is required if would like to enable the continuous backup feature. For example, you can perform continuous archive log backup half-hourly or hourly, for your Oracle instance.
- Java heap size: The default Java heap size setting on %edition_name% is 2048MB. For Oracle database backup it is highly recommended to increase the Java heap size setting to be at least 4096MB to improve backup and restore performance. The actual heap size is dependent on amount of free memory available on your Oracle server.
- Temporary Directory Folder: Temporary Directory folder is used by %edition_name% for Archive Log backup and any incremental or differential delta files generated during a backup job. To ensure optimal backup/restoration performance, it is recommended that the temporary directory folder is located on a local drive with sufficient free disk space.
The formula of calculation of disk space is as following:
(Total Database Size * Delta Ratio) * number of backup destinations = Maximum Free Space Required
For example: As the default Delta ratio is 50%, if the Oracle database size is 1TB and there is only one backup destination, the free space needed for temporary directory folder is 500GB.
- Hostname: To ensure that the restore to original location is supported, please enter 127.0.0.1 as the hostname during creating the Oracle backup set.
- Oracle Internal Process Checking: For the Oracle instance to run smoothly, please ensure that the internal processes for Oracle instance are working well, such as DBWO (Database Writer), LGWR (Log Writer), MMAN (Memory Manager Process), PMON (Process Monitor), PSPO (Process Spawner Process), SMON (System Monitor), CKPT (Checkpoint process (thread on Windows) that runs by default on Windows), ARCO (Archive Process (or thread on Windows)), RECO (Distributed Recovery Background Process).
SQL> select name, description from v$bgprocess where PADDR <>'00';
NAME     DESCRIPTION
-----   ---------------------------------------
PMON     process cleanup
VKTM     Virtual Keeper of TiMe process
GEN0     generic0
DIAG     diagnosibility process
DBRM     DataBase Resource Manager
VKRM     Virtual sKeduler for Resource Manager
PSP0     process spawner 0
DIA0     diagnosibility process 0
MMAN     Memory Manager
DBW0     db writer process 0
TMON     Transport Monitor
ARC0     Archival Process 0
ARC1     Archival Process 1
ARC2     Archival Process 2
ARC3     Archival Process 3
LGWR     Redo etc.
CKPT     checkpoint
SMON     System Monitor Process
SMCO     Space Manager Process
RECO     distributed recovery
LREG     Listener Registration
CJQ0     Job Queue Coordinator
AQPC     AQ Process Coord
MMON     Manageability Monitor Process
MMNL     Manageability Monitor Process 2
- Supported Oracle Database Server Version: Please ensure that the Oracle Database Server version is supported by %edition_name%.
SQL> select * from v$version;
Banner
---------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for 64-bit Windows: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 – Production
- System Identifier (SID): Check the SID through:
- SQL command
SQL > select instance from v$thread;
INSTANCE
--------------------------------------
Orcl12c
OR
- init.ora file in the path of “D:\app\oracle\admin”. Try to find the according sentences:
###########################################
# Database Identification
###########################################
db_domain=""
db_name="orcl12c"
- Oracle_home path: The Oracle_home path can be checked through:
- SQL command
SQL > SELECT file_spec FROM DBA_LIBRARIES WHERE library_name = 'DBMS_SUMADV_LIB';
FILE_SPEC
-----------------------------------------------
D:\app\oracle\product\12.1.0\dbhome_1\bin\oraqsmashr.dll
So the Oracle_home path is “D:\app\oracle”.
OR
- init.ora file in the path of “D:\app\oracle\admin”. Try to find the according sentences:
###########################################
# File Configuration
###########################################
control_files=("D:\app\oracle\oradata\orcl12c\control01.ctl", "D:\app\oracle\recovery_area\orcl12c\control02.ctl")
db_recovery_file_dest="D:\app\oracle\recovery_area"
db_recovery_file_dest_size=6930m
So the Oracle_home path is “D:\app\oracle”.
!
Please note that the value of the oracle_home path in init.ora file need to match the value obtained from SQL command. If the value does not match, please contact the Oracle database administrator for support.
- Oracle Port Number: Use netstat and tnsping to find out the port number and the default Oracle port number is 1521.
- NETSTAT
C:\Users\Administrator>netstat -a|more
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:135 w12x-5-43:0 LISTENING
TCP 0.0.0.0:445 w12x-5-43:0 LISTENING
TCP 0.0.0.0:1521 w12x-5-43:0 LISTENING
TCP 0.0.0.0:3389 w12x-5-43:0 LISTENING
TCP 10.16.10.81:139 w12x-5-43:0 LISTENING
TCP 10.16.10.81:1521 w12x-5-43:56851 ESTABLISHED
TCP 10.16.10.81:2030 w12x-5-43:0 LISTENING
TCP [::]:135 w12x-5-43:0 LISTENING
TCP [::]:445 w12x-5-43:0 LISTENING
TCP [::]:1521 w12x-5-43:0 LISTENING
TCP [::]:3389 w12x-5-43:0 LISTENING
TCP [fe80::4d71:5f81:58b0:552c%16]:2030 w12x-5-43:0 LISTENING
TCP [fe80::713e:e2d4:8e82:5f77%17]:1521 w12x-5-43:56760 ESTABLISHED
TCP [fe80::713e:e2d4:8e82:5f77%17]:2030 w12x-5-43:0 LISTENING
TCP [fe80::713e:e2d4:8e82:5f77%17]:56760 w12x-5-43:1521 ESTABLISHED
- TNSPING
C:\Users\Administrator>tnsping 127.0.0.1
TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 19-DEC-2017 15:38:56
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
D:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)
- Windows VSS Writer: The Windows VSS Writer is installed and running on the Oracle database server and the writer state is Stable. This can be verified by running the vssadmin list writers command.
C:\Users\Administrator>vssadmin list writers
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001-2012 Microsoft Corp.
Writer name: 'Task Scheduler Writer'
Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}
Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b}
State: [1] Stable
Last error: No error
Writer name: 'VSS Metadata Store Writer'
Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}
Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}
State: [1] Stable
Last error: No error
Writer name: 'Performance Counters Writer'
Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2}
Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}
State: [1] Stable
Last error: No error
Writer name: 'System Writer'
Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
Writer Instance Id: {635755cd-b461-426c-89d1-95682a185005}
State: [1] Stable
Last error: No error
Writer name: 'ASR Writer'
Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
Writer Instance Id: {b01dbf5b-b437-48ca-882f-c7ec08ef0a50}
State: [1] Stable
Last error: No error
Writer name: 'COM+ REGDB Writer'
Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
Writer Instance Id: {8fdde399-1d13-40e7-97c5-595bbf52b291}
State: [1] Stable
Last error: No error
Writer name: 'BITS Writer'
Writer Id: {4969d978-be47-48b0-b100-f328f07ac1e0}
Writer Instance Id: {7993a1e2-e51d-461f-b6f9-e64c93fad1ae}
State: [1] Stable
Last error: No error
Writer name: 'WMI Writer'
Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
Writer Instance Id: {792c367d-1e21-4644-a63a-7d8ee4e2aaac}
State: [1] Stable
Last error: No error
Writer name: 'Shadow Copy Optimization Writer'
Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}
Writer Instance Id: {82fd1722-afcd-4f8e-95fd-8e5a2111c84c}
State: [1] Stable
Last error: No error
Writer name: 'Registry Writer'
Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
Writer Instance Id: {723e8efc-3758-40c4-aaeb-88a4f43702d3}
State: [1] Stable
Last error: No error
- TNS Listener: TNS listener must be started to enable connection to Oracle. Use the following command to check if the TNS listener has been started:
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 06-MAR-2018 10:46:34
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias        LISTENER
Version      TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
Start Date   26-FEB-2018 15:20:48
Uptime       7 days 19 hr. 25 min. 46 sec
Trace Level   off
Security     ON: Local OS Authentication
SNMP         OFF
Listener Parameter File     D:\app\oracle\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File     D:\app\oracle\diag\tnslsnr\w12x-5-43\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=w12x-5-43)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=w12x-5-43)(PORT=5500))(Security=(my_wallet_directory=D:\APP\ORACLE\admin\orcl12c\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl12c" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12cXDB" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "pdborcl12c" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
The command completed successfully
If not,use the following command to start the TNS listener:
C:\Users\Administrator>lsnrctl start
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 19-DEC-2017 16:34:33
Copyright (c) 1991, 2013, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
ARCHIVELOG Mode and Database Status
- The database instance must be in ARCHIVELOG mode.
SQL > archive log list;
Database log mode Archive Mode
Automatic archival Enables
- Database status must be open.
SQL > select instance_name, status form v$instance;
INSTANCE_NAME     STATUS
-------------     ----------
Orcl12c           OPEN
- Java Installation: Java must be installed on the Oracle Database.
SQL > select comp_name, status from dba_registry;
COMP_NAME                               STATUS
---------                               ------------
OWB                                     VALID
Oracle Application Express               VALID
Oracle Enterprise Manager               VALID
OLAP Catalog                             VALID
Spatial                                 VALID
Oracle Multimedia                       VALID
Oracle XML Database                     VALID
Oracle Text                             VALID
Oracle Expression Filter                 VALID
Oracle Rules Manager                     VALID
Oracle Workspace Manager                 VALID
Oracle Database Catalog Views           VALID
Oracle Database Packages and Types       VALID
JServer JAVA Virtual Machine             VALID
Oracle XDK                               VALID
Oracle Database Java Package             VALID
- Oracle Login Account for Authentication of Backup/ Restore: The Oracle system account is used to connect to Oracle.
- Use the following command to check if the account has JavaSysPriv authentication:
SQL> select * from DBA_ROLE_PRIVS where upper(grantee)='SYSTEM';
GRANTEE   GRANTED_ROLE           ADM   DEF   COM
-------   ------------           ---   ---   ---
SYSTEM   JAVASYSPRIV             NO     YES   NO
SYSTEM   AQ_ADMINISTRATOR_ROLE   YES   YES   YES
If not, grant javasyspriv to the system account:
SQL> grant javasyspriv to system;
- Use the following command to check if the account has sysdba authentication:
SQL> select * from v$pwfile_users where sysdba='TRUE';
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
-------- ----- ----- ----- ----- ----- ----- ------
SYS       TRUE TRUE FALSE FALSE FALSE FALSE     0
SYSTEM   TRUE FALSE FALSE FALSE FALSE FALSE     1
If not, grant sysdba to the system account:
SQL> grant sysdba to system;
- Oracle Database Volumes: Oracle Database volumes must use a file system which supports the use of VSS snapshot as %edition_name% v7 apply VSS snapshot for Oracle database backup, for example NTFS.
- Windows user account permission: The Windows user account must be a member of the following security groups.
- ora_dba
- ORA_OraDB12Home1_STSBACKUP
- ORA_OraDB12Home1_SYSDG
- ORA_OraDB12Home1_SYSKM
- Oracle Database Related Windows Services: Ensure all Oracle database related services have been started.
- OracleJobSchedulerORCL12C
- OracleOraDB12Home1MTSRecoveryService
- OracleOraDB12Home1TNSListener
- OracleRemExecServiceV2
- OracleServiceORCL12C